create external table jms_dm.dm_spec_waybill_sum_dt 
(
    input_date              string comment  '录入日期'
    ,business_type_code     string comment  '业务类型code'
    ,business_type_name     string comment  '业务类型名称'
    ,business_type_name_en  string comment  '业务类型英文名称'
    ,agent_code             string comment  '代理区编码'
    ,agent_name             string comment  '代理区名称'
    ,brand_id               string comment  '品牌id'
    ,brand_name             string comment  '品牌名称'
    ,total_cnt              bigint comment  '总量'
    ,remind_cnt             bigint comment  '提醒量'
    ,not_remind_cnt         bigint comment  '未提醒量'
)
comment '操作平台-特殊件提醒汇总'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_spec_waybill_sum_dt'
TBLPROPERTIES (
    'discover.partitions' = 'false',
    'parquet.column.index.access' = 'true'
);
